Adding, deleting and renaming mappings
You can add, rename and delete mappings as required. For example, if you want one of the logical entities to contain columns from several tables in the landing zone, then you need to add a new mapping for each of the landing zone tables.
When mapping "From Date" columns in the Landing Zone to the "FD" Staging column, make sure that the dates in the Landing Zone columns are not earlier than the "Lowest Date" set in the Project Settings. Otherwise, any data with a "From Date" earlier than the "Lowest Date" will be ignored.
If some of the dates in the Landing Zone column are earlier than the "Lowest Date" and cannot be changed in the source, either change the "Lowest Date" set in the Project Settings - or - use a transformation in Replicate to convert the source dates to dates that are within"Lowest Date" to "Highest Date" range defined in your project.
To add, delete, and rename mappings:
-
Click the Manage button in the Data Warehouse panel. The Manage Data Warehouse Tasks window opens.
- In the left pane, select the task you want to add, delete, or rename.
- Select the Mappings tab.
Adding a new mapping
To add a new mapping:
- In the Logical Entities column, select the logical entity that you want to map.
-
Click the New button above the Logical Entities column. The New Mapping window opens.
- Optionally change the default mapping name.
- Click OK to save the mapping.
- Enable the mapping.
Deleting a mapping
To delete a mapping:
- In the Mappings column, hover the mouse cursor over the mapping you want to delete.
- Click the Delete (x) button that appears to its right.
- Click OK when prompted to confirm the deletion.
Renaming a mapping
To rename a mapping:
- In the Mappings column, hover the mouse cursor over the mapping you want to rename.
-
Click the Rename (A) button that appears to its right. The Rename window opens.
- Specify a new name for the mapping and then click OK.